Show All

Delete a PivotTable or PivotChart formula

For best results in a PivotChart report, work in the associated PivotTable report.

1. Determine whether the formula is in a calculated field or a calculated item.

   Calculated fields appear in the PivotTable Field List window. Calculated items appear as items within other fields.

2. Do one of the following:

   Delete a calculated field

   1. Click the report.
   2. On the PivotTable toolbar, click PivotTable or PivotChart, point to Formulas, and then click Calculated Field.
   3. In the Name box, click the field you want to delete.
   4. Click Delete.

   Delete a calculated item

   1. Click the field with the item you want to delete.
   2. On the PivotTable toolbar, click PivotTable or PivotChart, point to Formulas, and then click Calculated Item.
   3. In the Name box, click the item you want to delete.
   4. Click Delete.

Note  When you delete a formula from a PivotChart report or its associated PivotTable report, some chart formatting may be lost.

Tip